From 46a64a1aa242d417296ff9f0a42f1e236924fcb4 Mon Sep 17 00:00:00 2001
From: Stevan Earl <stevan.earl@asu.edu>
Date: Sun, 9 Aug 2026 18:08:00 -0700
Subject: [PATCH] fix: normalize missing groom-scan comments in clean

---
 conversion/clean.sql | 10 ++++++++++
 1 file changed, 10 insertions(+)

diff --git a/conversion/clean.sql b/conversion/clean.sql
index 06c6c80..39d38d3 100644
--- a/conversion/clean.sql
+++ b/conversion/clean.sql
@@ -569,6 +569,16 @@ UPDATE follow_arrival
   WHERE follow_arrival.fa_data_source IS NULL ;
 
 
+--
+-- Groom scans
+--
+
+-- EVENTS.Notes is NOT NULL but permits the empty string.
+UPDATE groom_scans
+  SET gs_comments = ''
+  WHERE gs_comments IS NULL;
+
+
 --
 -- Aggression
 --
-- 
2.34.1